{"statement":"SELECT * from ( select ref_0.c_city as c0, 97 as c1, ref_0.c_nation as c2, ref_0.c_nation as c3, ref_0.c_city as c4, ref_0.c_nation as c5, ref_0.c_region as c6, ref_0.c_name as c7, ref_0.c_phone as c8 from sqlsmith.ssb_100g_customer as ref_0 limit 117 ) as subq_0 inner join sqlsmith.tpch_100g_orders as ref_1 on (subq_0.c4 \u003d ref_1.O_ORDERSTATUS) inner join sqlsmith.tpcds_100g_item as ref_2 on (ref_1.O_ORDERPRIORITY \u003d ref_2.i_item_id) where (subq_0.c1 \u003d ref_2.i_brand_id);\n","table_meta":{"sqlsmith.tpcds_100g_item":"CREATE TABLE `tpcds_100g_item` (\n  `i_item_sk` int(11) NOT NULL COMMENT \"\",\n  `i_item_id` char(16) NOT NULL COMMENT \"\",\n  `i_rec_start_date` date NULL COMMENT \"\",\n  `i_rec_end_date` date NULL COMMENT \"\",\n  `i_item_desc` varchar(200) NULL COMMENT \"\",\n  `i_current_price` decimal64(7, 2) NULL COMMENT \"\",\n  `i_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `i_brand_id` int(11) NULL COMMENT \"\",\n  `i_brand` char(50) NULL COMMENT \"\",\n  `i_class_id` int(11) NULL COMMENT \"\",\n  `i_class` char(50) NULL COMMENT \"\",\n  `i_category_id` int(11) NULL COMMENT \"\",\n  `i_category` char(50) NULL COMMENT \"\",\n  `i_manufact_id` int(11) NULL COMMENT \"\",\n  `i_manufact` char(50) NULL COMMENT \"\",\n  `i_size` char(20) NULL COMMENT \"\",\n  `i_formulation` char(20) NULL COMMENT \"\",\n  `i_color` char(20) NULL COMMENT \"\",\n  `i_units` char(10) NULL COMMENT \"\",\n  `i_container` char(10) NULL COMMENT \"\",\n  `i_manager_id` int(11) NULL COMMENT \"\",\n  `i_product_name` char(50) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`i_item_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`i_item_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);","sqlsmith.ssb_100g_customer":"CREATE TABLE `ssb_100g_customer` (\n  `c_custkey` int(11) NOT NULL COMMENT \"\",\n  `c_name` varchar(26) NOT NULL COMMENT \"\",\n  `c_address` varchar(41) NOT NULL COMMENT \"\",\n  `c_city` varchar(11) NOT NULL COMMENT \"\",\n  `c_nation` varchar(16) NOT NULL COMMENT \"\",\n  `c_region` varchar(13) NOT NULL COMMENT \"\",\n  `c_phone` varchar(16) NOT NULL COMMENT \"\",\n  `c_mktsegment` varchar(11) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`c_custkey`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`c_custkey`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);","sqlsmith.tpch_100g_orders":"CREATE TABLE `tpch_100g_orders` (\n  `O_ORDERKEY` int(11) NOT NULL COMMENT \"\",\n  `O_CUSTKEY` int(11) NOT NULL COMMENT \"\",\n  `O_ORDERSTATUS` char(1) NOT NULL COMMENT \"\",\n  `O_TOTALPRICE` decimal64(15, 2) NOT NULL COMMENT \"\",\n  `O_ORDERDATE` date NOT NULL COMMENT \"\",\n  `O_ORDERPRIORITY` char(15) NOT NULL COMMENT \"\",\n  `O_CLERK` char(15) NOT NULL COMMENT \"\",\n  `O_SHIPPRIORITY` int(11) NOT NULL COMMENT \"\",\n  `O_COMMENT` varchar(79) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`O_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`O_ORDERKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);"},"table_row_count":{"sqlsmith.tpch_100g_orders":{"tpch_100g_orders":150000000},"sqlsmith.tpcds_100g_item":{"tpcds_100g_item":204000},"sqlsmith.ssb_100g_customer":{"ssb_100g_customer":3000000}},"session_variables":"{\"runtime_join_filter_push_down_limit\":1024000,\"codegen_level\":0,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":false,\"div_precision_increment\":4,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"auto_increment_increment\":1,\"foreign_key_checks\":true,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"character_set_results\":\"utf8\",\"parallel_fragment_exec_instance_num\":8,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"cbo_enable_dp_join_reorder\":true,\"cbo_enable_low_cardinality_optimize\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"new_planner_optimize_timeout\":3000,\"force_schedule_local\":false,\"pipeline_dop\":0,\"enable_query_dump\":false,\"cbo_enable_greedy_join_reorder\":true,\"prefer_join_method\":\"broadcast\",\"load_mem_limit\":0,\"sql_select_limit\":9223372036854775807,\"profiling\":false,\"sql_safe_updates\":0,\"enable_pipeline_engine\":false,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"normal\",\"enable_new_planner_push_down_join_to_agg\":false,\"broadcast_row_limit\":15000000,\"exec_mem_limit\":21474836480,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"enable_vectorized_insert\":true,\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"cbo_enable_replicated_join\":true,\"max_allowed_packet\":1048576,\"query_timeout\":180,\"enable_cbo\":true,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"max_execution_time\":3000000,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"pipeline_query_expire_seconds\":300,\"sql_mode\":0,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false}","column_statistics":{"sqlsmith.tpch_100g_orders":{"O_ORDERDATE":"[6.941952E8, 9.019872E8, 0.0, 4.0, 2406.0] ESTIMATE","O_COMMENT":"[-Infinity, Infinity, 0.0, 48.554745, 3.8696438E7] ESTIMATE","O_ORDERSTATUS":"[-Infinity, Infinity, 0.0, 1.0, 3.0] ESTIMATE","O_ORDERKEY":"[167.0, 9636134.0, 0.0, 4.0, 1.5E8] ESTIMATE","O_CUSTKEY":"[334.0, 1.4999926E7, 0.0, 4.0, 8407178.0] ESTIMATE","O_TOTALPRICE":"[868.41, 507160.63, 0.0, 8.0, 2.6944015E7] ESTIMATE","O_CLERK":"[-Infinity, Infinity, 0.0, 15.0, 100255.0] ESTIMATE","O_ORDERPRIORITY":"[-Infinity, Infinity, 0.0, 8.389825, 5.0] ESTIMATE","O_SHIPPRIORITY":"[0.0, 0.0, 0.0, 4.0, 1.0] ESTIMATE"},"sqlsmith.tpcds_100g_item":{"i_item_desc":"[-Infinity, Infinity, 0.0024213963385552335, 100.39858262709274, 144321.0] ESTIMATE","i_container":"[-Infinity, Infinity, 0.002439740250210955, 6.982921818248523, 2.0] ESTIMATE","i_wholesale_cost":"[0.02, 88.91, 0.0023113328686209045, 8.0, 6282.0] ESTIMATE","i_manufact_id":"[1.0, 1000.0, 0.0023174475058394786, 4.0, 1001.0] ESTIMATE","i_brand_id":"[1001001.0, 1.0016017E7, 0.0024519695246481028, 4.0, 953.0] ESTIMATE","i_formulation":"[-Infinity, Infinity, 0.0024152817013366598, 19.951694365973268, 147305.0] ESTIMATE","i_current_price":"[0.09, 99.99, 0.0024703134363038243, 8.0, 8575.0] ESTIMATE","i_size":"[-Infinity, Infinity, 0.002372479240806643, 4.320052341294591, 8.0] ESTIMATE","i_rec_start_date":"[8.778816E8, 1.004112E9, 0.0025070012596152672, 4.0, 5.0] ESTIMATE","i_manufact":"[-Infinity, Infinity, 0.0025620329945824313, 11.271379829034743, 1001.0] ESTIMATE","i_item_sk":"[1.0, 204000.0, 0.0, 4.0, 163542.0] ESTIMATE","i_manager_id":"[1.0, 100.0, 0.002366364603588069, 4.0, 101.0] ESTIMATE","i_item_id":"[-Infinity, Infinity, 0.0, 16.0, 98661.0] ESTIMATE","i_class_id":"[1.0, 16.0, 0.0023357914174952, 4.0, 17.0] ESTIMATE","i_class":"[-Infinity, Infinity, 0.0023113328686209045, 7.772064668403224, 100.0] ESTIMATE","i_category":"[-Infinity, Infinity, 0.0022929889569651835, 5.890749776815741, 11.0] ESTIMATE","i_category_id":"[1.0, 10.0, 0.002439740250210955, 4.0, 11.0] ESTIMATE","i_brand":"[-Infinity, Infinity, 0.002427510975773807, 16.114313142801237, 713.0] ESTIMATE","i_units":"[-Infinity, Infinity, 0.002366364603588069, 4.179305621797459, 22.0] ESTIMATE","i_rec_end_date":"[9.409536E8, 1.0040256E9, 0.5006359222707317, 4.0, 4.0] ESTIMATE","i_color":"[-Infinity, Infinity, 0.0024886573479595457, 5.364725880813491, 93.0] ESTIMATE","i_product_name":"[-Infinity, Infinity, 0.0024580841618666764, 22.286342346308594, 203376.0] ESTIMATE"},"sqlsmith.ssb_100g_customer":{"c_phone":"[-Infinity, Infinity, 0.0, 15.0, 3000000.0] ESTIMATE","c_nation":"[-Infinity, Infinity, 0.0, 7.08167, 25.0] ESTIMATE","c_name":"[-Infinity, Infinity, 0.0, 18.0, 3000000.0] ESTIMATE","c_region":"[-Infinity, Infinity, 0.0, 6.79527, 5.0] ESTIMATE","c_city":"[-Infinity, Infinity, 0.0, 10.0, 250.0] ESTIMATE"}},"be_number":3,"exception":[]}